package com.c.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.c.entity.Member;
import org.springframework.stereotype.Repository;

/**
 * @author wangxiangli
 * @create 2022-12-30-15:18
 */
@Repository
public interface MemberMapper extends BaseMapper<Member> {
    //手机唯一性查询
    Integer findByPhone(String phoneNumber);
    //根据会员ID统计数据量
    long findCountByCheckMemberId(Integer id);
    //根据日期统计会员数，统计指定日期之前的会员数
    Integer findMemberCountBeforeDate(String month);
    //查询今天新增会员数
    Integer findMemberCountByDate(String today);
    //总会员数
    Integer findMemberTotalCount();
    //本周新增会员数
    Integer findMemberCountAfterDate(String thisWeekMonday);
}
